Pandas Profiling Report

Dataset statistics

Number of variables	11
Number of observations	2930
Missing cells	2
Missing cells (%)	< 0.1%
Duplicate rows	4
Duplicate rows (%)	0.1%
Total size in memory	251.9 KiB
Average record size in memory	88.0 B

Variable types

Numeric	10
Categorical	1

Alerts

Dataset has 4 (0.1%) duplicate rows	Duplicates
`Total Bsmt SF` has 79 (2.7%) zeros	Zeros
`2nd Flr SF` has 1678 (57.3%) zeros	Zeros
`Garage Cars` has 157 (5.4%) zeros	Zeros
`Open Porch SF` has 1300 (44.4%) zeros	Zeros

Reproduction

Analysis started	2024-01-02 21:48:47.111953
Analysis finished	2024-01-02 21:49:01.503226
Duration	14.39 seconds
Software version	ydata-profiling vv4.6.3
Download configuration	config.json

Lot Area
Real number (ℝ)

Distinct	1960
Distinct (%)	66.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10147.922

Minimum	1300
Maximum	215245
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	1300
5-th percentile	3188.3
Q1	7440.25
median	9436.5
Q3	11555.25
95-th percentile	17131
Maximum	215245
Range	213945
Interquartile range (IQR)	4115

Descriptive statistics

Standard deviation	7880.0178
Coefficient of variation (CV)	0.77651542
Kurtosis	265.02367
Mean	10147.922
Median Absolute Deviation (MAD)	2040
Skewness	12.820898
Sum	29733411
Variance	62094680
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9600	44	1.5%
7200	43	1.5%
6000	34	1.2%
9000	29	1.0%
10800	25	0.9%
8400	21	0.7%
7500	21	0.7%
6240	18	0.6%
1680	18	0.6%
6120	17	0.6%
Other values (1950)	2660	90.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1300	1	< 0.1%
1470	1	< 0.1%
1476	1	< 0.1%
1477	2	0.1%
1484	1	< 0.1%
1488	1	< 0.1%
1491	1	< 0.1%
1495	1	< 0.1%
1504	1	< 0.1%
1526	2	0.1%

Value	Count	Frequency (%)
215245	1	< 0.1%
164660	1	< 0.1%
159000	1	< 0.1%
115149	1	< 0.1%
70761	1	< 0.1%
63887	1	< 0.1%
57200	1	< 0.1%
56600	1	< 0.1%
53504	1	< 0.1%
53227	1	< 0.1%

Overall Qual
Real number (ℝ)

Distinct	10
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0948805

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	5
median	6
Q3	7
95-th percentile	8
Maximum	10
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.4110261
Coefficient of variation (CV)	0.23151005
Kurtosis	0.05241245
Mean	6.0948805
Median Absolute Deviation (MAD)	1
Skewness	0.19063396
Sum	17858
Variance	1.9909946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	825	28.2%
6	732	25.0%
7	602	20.5%
8	350	11.9%
4	226	7.7%
9	107	3.7%
3	40	1.4%
10	31	1.1%
2	13	0.4%
1	4	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	0.1%
2	13	0.4%
3	40	1.4%
4	226	7.7%
5	825	28.2%
6	732	25.0%
7	602	20.5%
8	350	11.9%
9	107	3.7%
10	31	1.1%

Value	Count	Frequency (%)
10	31	1.1%
9	107	3.7%
8	350	11.9%
7	602	20.5%
6	732	25.0%
5	825	28.2%
4	226	7.7%
3	40	1.4%
2	13	0.4%
1	4	0.1%

Overall Cond
Real number (ℝ)

Distinct	9
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5631399

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	5
median	5
Q3	6
95-th percentile	8
Maximum	9
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1115366
Coefficient of variation (CV)	0.19980381
Kurtosis	1.4914497
Mean	5.5631399
Median Absolute Deviation (MAD)	0
Skewness	0.57442948
Sum	16300
Variance	1.2355135
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
5	1654	56.5%
6	533	18.2%
7	390	13.3%
8	144	4.9%
4	101	3.4%
3	50	1.7%
9	41	1.4%
2	10	0.3%
1	7	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7	0.2%
2	10	0.3%
3	50	1.7%
4	101	3.4%
5	1654	56.5%
6	533	18.2%
7	390	13.3%
8	144	4.9%
9	41	1.4%

Value	Count	Frequency (%)
9	41	1.4%
8	144	4.9%
7	390	13.3%
6	533	18.2%
5	1654	56.5%
4	101	3.4%
3	50	1.7%
2	10	0.3%
1	7	0.2%

Year Built
Real number (ℝ)

Distinct	118
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.3563

Minimum	1872
Maximum	2010
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	1872
5-th percentile	1915
Q1	1954
median	1973
Q3	2001
95-th percentile	2007
Maximum	2010
Range	138
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	30.245361
Coefficient of variation (CV)	0.015342412
Kurtosis	-0.50171504
Mean	1971.3563
Median Absolute Deviation (MAD)	25
Skewness	-0.60446222
Sum	5776074
Variance	914.78184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2005	142	4.8%
2006	138	4.7%
2007	109	3.7%
2004	99	3.4%
2003	88	3.0%
1977	57	1.9%
1920	57	1.9%
1976	54	1.8%
1999	52	1.8%
2008	49	1.7%
Other values (108)	2085	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1872	1	< 0.1%
1875	1	< 0.1%
1879	1	< 0.1%
1880	5	0.2%
1882	1	< 0.1%
1885	2	0.1%
1890	7	0.2%
1892	2	0.1%
1893	1	< 0.1%
1895	3	0.1%

Value	Count	Frequency (%)
2010	3	0.1%
2009	25	0.9%
2008	49	1.7%
2007	109	3.7%
2006	138	4.7%
2005	142	4.8%
2004	99	3.4%
2003	88	3.0%
2002	47	1.6%
2001	35	1.2%

Total Bsmt SF
Real number (ℝ)

ZEROS

Distinct	1058
Distinct (%)	36.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1051.6145

Minimum	0
Maximum	6110
Zeros	79
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	0
5-th percentile	453
Q1	793
median	990
Q3	1302
95-th percentile	1776
Maximum	6110
Range	6110
Interquartile range (IQR)	509

Descriptive statistics

Standard deviation	440.61507
Coefficient of variation (CV)	0.41898913
Kurtosis	9.1356123
Mean	1051.6145
Median Absolute Deviation (MAD)	236
Skewness	1.1562043
Sum	3080179
Variance	194141.64
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	79	2.7%
864	74	2.5%
672	29	1.0%
912	26	0.9%
1040	25	0.9%
768	24	0.8%
816	23	0.8%
728	21	0.7%
780	19	0.6%
384	19	0.6%
Other values (1048)	2590	88.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	79	2.7%
105	1	< 0.1%
160	1	< 0.1%
173	1	< 0.1%
190	1	< 0.1%
192	1	< 0.1%
216	2	0.1%
240	1	< 0.1%
245	1	< 0.1%
264	4	0.1%

Value	Count	Frequency (%)
6110	1	< 0.1%
5095	1	< 0.1%
3206	1	< 0.1%
3200	1	< 0.1%
3138	1	< 0.1%
3094	1	< 0.1%
2846	1	< 0.1%
2660	1	< 0.1%
2633	1	< 0.1%
2630	1	< 0.1%

1st Flr SF
Real number (ℝ)

Distinct	1083
Distinct (%)	37.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1159.5577

Minimum	334
Maximum	5095
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	334
5-th percentile	665.45
Q1	876.25
median	1084
Q3	1384
95-th percentile	1829.55
Maximum	5095
Range	4761
Interquartile range (IQR)	507.75

Descriptive statistics

Standard deviation	391.89089
Coefficient of variation (CV)	0.33796584
Kurtosis	6.9688085
Mean	1159.5577
Median Absolute Deviation (MAD)	236
Skewness	1.4694286
Sum	3397504
Variance	153578.47
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
864	46	1.6%
1040	28	1.0%
912	19	0.6%
816	18	0.6%
848	18	0.6%
960	18	0.6%
672	17	0.6%
894	17	0.6%
936	17	0.6%
546	15	0.5%
Other values (1073)	2717	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
334	1	< 0.1%
372	1	< 0.1%
407	1	< 0.1%
432	1	< 0.1%
438	1	< 0.1%
442	1	< 0.1%
448	1	< 0.1%
453	1	< 0.1%
480	1	< 0.1%
483	13	0.4%

Value	Count	Frequency (%)
5095	1	< 0.1%
4692	1	< 0.1%
3820	1	< 0.1%
3228	1	< 0.1%
3138	1	< 0.1%
2898	1	< 0.1%
2726	1	< 0.1%
2696	1	< 0.1%
2674	1	< 0.1%
2633	1	< 0.1%

2nd Flr SF
Real number (ℝ)

ZEROS

Distinct	635
Distinct (%)	21.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	335.45597

Minimum	0
Maximum	2065
Zeros	1678
Zeros (%)	57.3%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	703.75
95-th percentile	1130.1
Maximum	2065
Range	2065
Interquartile range (IQR)	703.75

Descriptive statistics

Standard deviation	428.39572
Coefficient of variation (CV)	1.277055
Kurtosis	-0.4148613
Mean	335.45597
Median Absolute Deviation (MAD)	0
Skewness	0.86645675
Sum	982886
Variance	183522.89
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1678	57.3%
546	23	0.8%
728	18	0.6%
504	17	0.6%
720	13	0.4%
600	13	0.4%
672	13	0.4%
896	11	0.4%
886	10	0.3%
756	9	0.3%
Other values (625)	1125	38.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1678	57.3%
110	1	< 0.1%
125	1	< 0.1%
144	1	< 0.1%
167	1	< 0.1%
180	1	< 0.1%
182	1	< 0.1%
185	1	< 0.1%
192	1	< 0.1%
208	2	0.1%

Value	Count	Frequency (%)
2065	1	< 0.1%
1872	1	< 0.1%
1862	1	< 0.1%
1836	1	< 0.1%
1818	1	< 0.1%
1796	1	< 0.1%
1788	1	< 0.1%
1778	1	< 0.1%
1721	1	< 0.1%
1629	1	< 0.1%

Fireplaces
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.0 KiB

0	1422
1	1274
2	221
3	12
4	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2930
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	2
2nd row	0
3rd row	0
4th row	2
5th row	1

Common Values

Value	Count	Frequency (%)
0	1422	48.5%
1	1274	43.5%
2	221	7.5%
3	12	0.4%
4	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1422	48.5%
1	1274	43.5%
2	221	7.5%
3	12	0.4%
4	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	1422	48.5%
1	1274	43.5%
2	221	7.5%
3	12	0.4%
4	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2930	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1422	48.5%
1	1274	43.5%
2	221	7.5%
3	12	0.4%
4	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	2930	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1422	48.5%
1	1274	43.5%
2	221	7.5%
3	12	0.4%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2930	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1422	48.5%
1	1274	43.5%
2	221	7.5%
3	12	0.4%
4	1	< 0.1%

Garage Cars
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	0.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.7668146

Minimum	0
Maximum	5
Zeros	157
Zeros (%)	5.4%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.76056636
Coefficient of variation (CV)	0.43047321
Kurtosis	0.24496945
Mean	1.7668146
Median Absolute Deviation (MAD)	0
Skewness	-0.21983636
Sum	5175
Variance	0.5784612
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	1603	54.7%
1	778	26.6%
3	374	12.8%
0	157	5.4%
4	16	0.5%
5	1	< 0.1%
(Missing)	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	5.4%
1	778	26.6%
2	1603	54.7%
3	374	12.8%
4	16	0.5%
5	1	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	16	0.5%
3	374	12.8%
2	1603	54.7%
1	778	26.6%
0	157	5.4%

Open Porch SF
Real number (ℝ)

ZEROS

Distinct	252
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.533447

Minimum	0
Maximum	742
Zeros	1300
Zeros (%)	44.4%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	27
Q3	70
95-th percentile	182.55
Maximum	742
Range	742
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	67.4834
Coefficient of variation (CV)	1.4197035
Kurtosis	10.954343
Mean	47.533447
Median Absolute Deviation (MAD)	27
Skewness	2.5353859
Sum	139273
Variance	4554.0093
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1300	44.4%
36	52	1.8%
48	52	1.8%
40	44	1.5%
32	38	1.3%
24	36	1.2%
28	35	1.2%
20	33	1.1%
30	31	1.1%
60	30	1.0%
Other values (242)	1279	43.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1300	44.4%
4	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
10	2	0.1%
11	3	0.1%
12	5	0.2%
15	2	0.1%
16	15	0.5%
17	2	0.1%

Value	Count	Frequency (%)
742	1	< 0.1%
570	1	< 0.1%
547	1	< 0.1%
523	1	< 0.1%
502	1	< 0.1%
484	1	< 0.1%
444	1	< 0.1%
418	1	< 0.1%
406	1	< 0.1%
382	1	< 0.1%

SalePrice
Real number (ℝ)

Distinct	1032
Distinct (%)	35.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180796.06

Minimum	12789
Maximum	755000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.0 KiB

Quantile statistics

Minimum	12789
5-th percentile	87500
Q1	129500
median	160000
Q3	213500
95-th percentile	335000
Maximum	755000
Range	742211
Interquartile range (IQR)	84000

Descriptive statistics

Standard deviation	79886.692
Coefficient of variation (CV)	0.4418608
Kurtosis	5.1189
Mean	180796.06
Median Absolute Deviation (MAD)	37000
Skewness	1.7435001
Sum	5.2973246 × 10⁸
Variance	6.3818836 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
135000	34	1.2%
140000	33	1.1%
130000	29	1.0%
155000	28	1.0%
145000	26	0.9%
160000	23	0.8%
185000	21	0.7%
110000	21	0.7%
115000	20	0.7%
120000	20	0.7%
Other values (1022)	2675	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12789	1	< 0.1%
13100	1	< 0.1%
34900	1	< 0.1%
35000	1	< 0.1%
35311	1	< 0.1%
37900	1	< 0.1%
39300	1	< 0.1%
40000	1	< 0.1%
44000	1	< 0.1%
45000	1	< 0.1%

Value	Count	Frequency (%)
755000	1	< 0.1%
745000	1	< 0.1%
625000	1	< 0.1%
615000	1	< 0.1%
611657	1	< 0.1%
610000	1	< 0.1%
591587	1	< 0.1%
584500	1	< 0.1%
582933	1	< 0.1%
556581	1	< 0.1%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Lot Area	Overall Qual	Overall Cond	Year Built	Total Bsmt SF	1st Flr SF	2nd Flr SF	Fireplaces	Garage Cars	Open Porch SF	SalePrice
0	31770	6	5	1960	1080.0	1656	0	2	2.0	62	215000
1	11622	5	6	1961	882.0	896	0	0	1.0	0	105000
2	14267	6	6	1958	1329.0	1329	0	0	1.0	36	172000
3	11160	7	5	1968	2110.0	2110	0	2	2.0	0	244000
4	13830	5	5	1997	928.0	928	701	1	2.0	34	189900
5	9978	6	6	1998	926.0	926	678	1	2.0	36	195500
6	4920	8	5	2001	1338.0	1338	0	0	2.0	0	213500
7	5005	8	5	1992	1280.0	1280	0	0	2.0	82	191500
8	5389	8	5	1995	1595.0	1616	0	1	2.0	152	236500
9	7500	7	5	1999	994.0	1028	776	1	2.0	60	189000

	Lot Area	Overall Qual	Overall Cond	Year Built	Total Bsmt SF	1st Flr SF	2nd Flr SF	Fireplaces	Garage Cars	Open Porch SF	SalePrice
2920	1894	4	5	1970	546.0	546	546	0	1.0	24	71000
2921	12640	6	5	1976	1728.0	1728	0	0	2.0	0	150900
2922	9297	5	5	1976	1728.0	1728	0	0	2.0	0	188000
2923	17400	5	5	1977	1126.0	1126	0	1	2.0	41	160000
2924	20000	5	7	1960	1224.0	1224	0	1	2.0	0	131000
2925	7937	6	6	1984	1003.0	1003	0	0	2.0	0	142500
2926	8885	5	5	1983	864.0	902	0	0	2.0	0	131000
2927	10441	5	5	1992	912.0	970	0	0	0.0	32	132000
2928	10010	5	5	1974	1389.0	1389	0	1	2.0	38	170000
2929	9627	7	5	1993	996.0	996	1004	1	3.0	48	188000

Most frequently occurring

	Lot Area	Overall Qual	Overall Cond	Year Built	Total Bsmt SF	1st Flr SF	Fireplaces	Garage Cars	Open Porch SF	SalePrice	# duplicates
0	3675	6	5	2005	547.0	1072	0	2.0	44	140000	2
1	4590	8	5	2006	1554.0	1554	1	2.0	73	209500	2
2	7018	5	5	1979	0.0	1535	0	2.0	0	118858	2
3	10800	5	5	1987	1200.0	1200	0	0.0	0	179000	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Missing values

Sample

Duplicate rows

Most frequently occurring